*******************************************************
* Lyle 05 Jan 11: 						              *
*	-this program serves as a base shell for all	  *
*	 stata do files					                  *
*******************************************************

********************************
* Standard Stata Configuration *
********************************
clear all
set mem 999m
capture log close
set logtype text
cap cd "C:\Users\ejm5\Google Drive\2017_Research\Unemployment_MILEX"
cap cd "C:\Users\Jordan.Becker\Desktop\GD\2017_Research\Unemployment_MILEX"
cap cd "\\usnatonetapp01.eur.state.sbu\profiles\beckerjm\Desktop\2017_Research\Unemployment_MILEX"
log using "log\sgp_table1.log", replace
set more off


********************
* Analyze the Data *
********************
#delimit;
use "dta\2017_uem", clear;
sort ccode year;
xtset ccode year;


*Table 1: Summary/Descriptive Stats*
#delimit;

sum milburden_publiccon milburden personnel equipment operating infrastructure fri_new ln_spillins ln_wdi_gdp ln_pop sandler_strategic threat right newatlanticism years_nato;

sum milburden_publiccon milburden personnel equipment operating infrastructure fri_new ln_spillins ln_wdi_gdp ln_pop sandler_strategic threat right newatlanticism years_nato if education_quartile==1;

sum milburden_publiccon milburden personnel equipment operating infrastructure fri_new ln_spillins ln_wdi_gdp ln_pop sandler_strategic threat right newatlanticism years_nato if education_quartile==2;

sum milburden_publiccon milburden personnel equipment operating infrastructure fri_new ln_spillins ln_wdi_gdp ln_pop sandler_strategic threat right newatlanticism years_nato if education_quartile==3;

sum milburden_publiccon milburden personnel equipment operating infrastructure fri_new ln_spillins ln_wdi_gdp ln_pop sandler_strategic threat right newatlanticism years_nato if education_quartile==4;


